geospatial analysis
Andrew Ba Tran
March 15, 2016
Geospatial analysis
Just different approaches to analyzing drug overdoses in Connecticut.
source("prepping_data.R")##
## Attaching package: 'tidyr'## The following object is masked from 'package:raster':
##
## extract## The following object is masked from 'package:reshape':
##
## expand## Joining by: "name2"## Your file with fixed town names has been exported.
## Unfortunately, no matches were found for 111 They can be found in your folder. The file is called no_matches.csv## Joining by: "name2"## Your file with fixed town names has been exported.
## Unfortunately, no matches were found for 2 They can be found in your folder. The file is called no_matches.csv[1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## Joining by: "Year"## Joining by: "Year"## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vectordrugs_total <- raw_ct %>%
group_by(Residence.City) %>%
dplyr::summarize(Total=n())
colnames(drugs_total) <- c("id", "Total")
drugs_total <- ctpopulator(id, drugs_total)## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vectordrugs_total$percapita <- round((drugs_total$Total/drugs_total$pop2013)*10000,2)
drugs_total$id <- str_to_title(drugs_total$id)
gpclibPermit()## Warning in gpclibPermit(): support for gpclib will be withdrawn from
## maptools at the next major release## [1] TRUEgpclibPermitStatus()## [1] TRUEtowntracts <- readOGR(dsn="maps", layer="ctgeo")## OGR data source with driver: ESRI Shapefile
## Source: "maps", layer: "ctgeo"
## with 169 features
## It has 6 fieldstowntracts_only <- towntracts
towntracts <- fortify(towntracts, region="NAME10")
drugs_total_map <- left_join(towntracts, drugs_total)## Joining by: "id"# Towns overall (total)
dtm <- ggplot() +
geom_polygon(data = drugs_total_map, aes(x=long, y=lat, group=group, fill=Total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town since 2012", fill="")
dtm
# Towns in 2014 (total)
y2012 <- raw_ct %>%
filter(Year==2012)
drugs_total_2012 <- y2012 %>%
group_by(Residence.City) %>%
dplyr::summarize(Total=n())
colnames(drugs_total_2012) <- c("id", "Total")
drugs_total_2012 <- ctpopulator(id, drugs_total_2012)## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vectordrugs_total_2012$percapita <- round((drugs_total_2012$Total/drugs_total_2012$pop2013)*10000,2)
drugs_total_2012$id <- str_to_title(drugs_total_2012$id)
drugs_total_map12 <- left_join(towntracts, drugs_total_2012)## Joining by: "id"dtm12 <- ggplot() +
geom_polygon(data = drugs_total_map12, aes(x=long, y=lat, group=group, fill=Total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town in 2012", fill="")
dtm12
# Totals over time by town
y2013 <- raw_ct %>%
filter(Year==2013)
drugs_total_2013 <- y2013 %>%
group_by(Residence.City) %>%
dplyr::summarize(Total=n())
colnames(drugs_total_2013) <- c("id", "Total")
drugs_total_2013 <- ctpopulator(id, drugs_total_2013)## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vectordrugs_total_2013$percapita <- round((drugs_total_2013$Total/drugs_total_2013$pop2013)*10000,2)
drugs_total_2013$id <- str_to_title(drugs_total_2013$id)
drugs_total_map13 <- left_join(towntracts, drugs_total_2013)## Joining by: "id"dtm13 <- ggplot() +
geom_polygon(data = drugs_total_map13, aes(x=long, y=lat, group=group, fill=Total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town in 2013", fill="")
dtm13
y2014 <- raw_ct %>%
filter(Year==2014)
drugs_total_2014 <- y2014 %>%
group_by(Residence.City) %>%
dplyr::summarize(Total=n())
colnames(drugs_total_2014) <- c("id", "Total")
drugs_total_2014 <- ctpopulator(id, drugs_total_2014)## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vectordrugs_total_2014$percapita <- round((drugs_total_2014$Total/drugs_total_2014$pop2013)*10000,2)
drugs_total_2014$id <- str_to_title(drugs_total_2014$id)
drugs_total_map14 <- left_join(towntracts, drugs_total_2014)## Joining by: "id"dtm14 <- ggplot() +
geom_polygon(data = drugs_total_map14, aes(x=long, y=lat, group=group, fill=Total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town in 2014", fill="")
dtm14
y2015 <- raw_ct %>%
filter(Year==2015)
drugs_total_2015 <- y2015 %>%
group_by(Residence.City) %>%
dplyr::summarize(Total=n())
colnames(drugs_total_2015) <- c("id", "Total")
drugs_total_2015 <- ctpopulator(id, drugs_total_2015)## [1] "Checking to see if names match..."## Joining by: "name2"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vectordrugs_total_2015$percapita <- round((drugs_total_2015$Total/drugs_total_2015$pop2013)*10000,2)
drugs_total_2015$id <- str_to_title(drugs_total_2015$id)
drugs_total_map15 <- left_join(towntracts, drugs_total_2015)## Joining by: "id"dtm15 <- ggplot() +
geom_polygon(data = drugs_total_map15, aes(x=long, y=lat, group=group, fill=Total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town in 2015", fill="")
dtm15
# Towns overall (rate)
dtm <- ggplot() +
geom_polygon(data = drugs_total_map, aes(x=long, y=lat, group=group, fill=percapita), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Overdose deaths rate by town since 2012", fill="")
dtm
# Towns over time (rate)
dtm <- ggplot() +
geom_polygon(data = drugs_total_map12, aes(x=long, y=lat, group=group, fill=percapita), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Overdose deaths rate by town in 2012", fill="")
dtm
dtm <- ggplot() +
geom_polygon(data = drugs_total_map13, aes(x=long, y=lat, group=group, fill=percapita), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Overdose deaths rate by town in 2013", fill="")
dtm
dtm <- ggplot() +
geom_polygon(data = drugs_total_map14, aes(x=long, y=lat, group=group, fill=percapita), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Overdose deaths rate by town in 2014", fill="")
dtm
dtm <- ggplot() +
geom_polygon(data = drugs_total_map15, aes(x=long, y=lat, group=group, fill=percapita), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Overdose deaths rate by town in 2015", fill="")
dtm
# Where people come from if they dont come from CT
not_ct <- raw_not_ct %>%
group_by(Residence.State) %>%
summarise(Total=n())
ggplot(not_ct, aes(x=Residence.State, y=Total)) + geom_bar(stat="identity") + labs(title="Out of state visitors who died in Connecticut")
# points on a polygon for towns
## This location-specific data was taken from the state website. Names were stripped from the dataset before uploading.
test <- read.csv("data/raw_data_2014.csv", stringsAsFactors=FALSE)
coords <- cbind(test$X, test$Y)
sp <- SpatialPoints(coords)
proj4string(sp) <- "+proj=longlat +datum=WGS84 +no_defs +ellps=WGS84 +towgs84=0,0,0"
proj4string(sp)## [1] "+proj=longlat +datum=WGS84 +no_defs +ellps=WGS84 +towgs84=0,0,0"plot(towntracts_only)
plot(sp, col="red" , add=TRUE)
res <- over(sp, towntracts_only)
# points on a polygon for census tracts
censustracts <- readOGR(dsn="maps/census_tracts/wgs84", layer="tractct_37800_0000_2010_s100_census_1_shp_wgs84")## OGR data source with driver: ESRI Shapefile
## Source: "maps/census_tracts/wgs84", layer: "tractct_37800_0000_2010_s100_census_1_shp_wgs84"
## with 833 features
## It has 14 fieldsplot(censustracts)
plot(sp, col="red" , add=TRUE)
res <- over(sp, censustracts)
census_tracts <- res %>%
group_by(NAME10) %>%
summarise(Total=n())
censustracts <- fortify(censustracts, region="NAME10")
colnames(census_tracts) <- c("id", "total")
drugs_total_tracts <- left_join(censustracts, census_tracts)## Joining by: "id"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector# Towns overall (total)
dtm <- ggplot() +
geom_polygon(data = drugs_total_tracts, aes(x=long, y=lat, group=group, fill=total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by census tract in 2014", fill="")
dtm
# points on a polygon for blocks
censusblocks <- readOGR(dsn="maps/census_blocks/wgs84", layer="blockct_37800_0000_2010_s100_census_1_shp_wgs84")## OGR data source with driver: ESRI Shapefile
## Source: "maps/census_blocks/wgs84", layer: "blockct_37800_0000_2010_s100_census_1_shp_wgs84"
## with 67578 features
## It has 15 fieldsplot(censusblocks)
plot(sp, col="red" , add=TRUE)
res <- over(sp, censusblocks)
census_blocks <- res %>%
group_by(GEOID10) %>%
summarise(Total=n())
censusblocks <- fortify(censusblocks, region="GEOID10")
colnames(census_blocks) <- c("id", "total")
drugs_total_blocks <- left_join(censusblocks, census_blocks)## Joining by: "id"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector# Towns overall (total)
dtm <- ggplot() +
geom_polygon(data = drugs_total_blocks, aes(x=long, y=lat, group=group, fill=total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by census block in 2014", fill="")
dtm
# points on a polygon for block groups
censusblockgroups <- readOGR(dsn="maps/census_block_groups/wgs84", layer="blockgroupct_37800_0000_2010_s100_census_1_shp_wgs84")## OGR data source with driver: ESRI Shapefile
## Source: "maps/census_block_groups/wgs84", layer: "blockgroupct_37800_0000_2010_s100_census_1_shp_wgs84"
## with 2585 features
## It has 13 fieldsplot(censusblockgroups)
plot(sp, col="red" , add=TRUE)
res <- over(sp, censusblockgroups)
census_block_groups <- res %>%
group_by(GEOID10) %>%
summarise(Total=n())
censusblockgroups <- fortify(censusblockgroups, region="GEOID10")
colnames(census_block_groups) <- c("id", "total")
drugs_total_block_groups <- left_join(censusblockgroups, census_block_groups)## Joining by: "id"## Warning in left_join_impl(x, y, by$x, by$y): joining factor and character
## vector, coercing into character vector# Towns overall (total)
dtm <- ggplot() +
geom_polygon(data = drugs_total_block_groups, aes(x=long, y=lat, group=group, fill=total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by census block group in 2014", fill="")
dtm
residence_towns <- raw_ct %>%
group_by(Residence.City) %>%
summarise(total=n())
# heatmap and points of reference (hospitals, pharmacies with narcan, methadone clinics?)
ct_map <- get_map(location = "connecticut", maptype = "satellite", zoom = 9)## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=connecticut&zoom=9&size=640x640&scale=2&maptype=satellite&language=en-EN&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=connecticut&sensor=falsect_gg <- read.csv("data/raw_data_2014.csv", stringsAsFactors=FALSE)
# overall points on the map
ggmap(ct_map, extent = "device") + geom_point(aes(x = X, y = Y), colour = "red",
alpha = 0.1, size = 2, data = ct_gg)## Warning: Removed 69 rows containing missing values (geom_point).
## SUB CODE??
stat_density_2d <- function(mapping = NULL, data = NULL, geom = "density_2d",
position = "identity", contour = TRUE,
n = 100, h = NULL, na.rm = FALSE,bins=0,
show.legend = NA, inherit.aes = TRUE, ...) {
layer(
data = data,
mapping = mapping,
stat = StatDensity2d,
geom = geom,
position = position,
show.legend = show.legend,
inherit.aes = inherit.aes,
params = list(
na.rm = na.rm,
contour = contour,
n = n,
bins=bins,
...
)
)
}
stat_density2d <- stat_density_2d
StatDensity2d <-
ggproto("StatDensity2d", Stat,
default_aes = aes(colour = "#3366FF", size = 0.5),
required_aes = c("x", "y"),
compute_group = function(data, scales, na.rm = FALSE, h = NULL,
contour = TRUE, n = 100,bins=0) {
if (is.null(h)) {
h <- c(MASS::bandwidth.nrd(data$x), MASS::bandwidth.nrd(data$y))
}
dens <- MASS::kde2d(
data$x, data$y, h = h, n = n,
lims = c(scales$x$dimension(), scales$y$dimension())
)
df <- data.frame(expand.grid(x = dens$x, y = dens$y), z = as.vector(dens$z))
df$group <- data$group[1]
if (contour) {
# StatContour$compute_panel(df, scales,bins=bins,...) # bad dots...
if (bins>0){
StatContour$compute_panel(df, scales,bins)
} else {
StatContour$compute_panel(df, scales)
}
} else {
names(df) <- c("x", "y", "density", "group")
df$level <- 1
df$piece <- 1
df
}
}
)
# heatmap
ggmap(ct_map, extent = "device") + geom_density2d(data = ct_gg,
aes(x = X, y = Y), size = 0.3) + stat_density2d(data = ct_gg,
aes(x = X, y = Y, fill = ..level.., alpha = ..level..), size = 0.01,
bins=16, geom = "polygon") + scale_fill_gradient(low = "green", high = "red") +
scale_alpha(range = c(0, 0.3), guide = FALSE)## Warning: Removed 69 rows containing non-finite values (stat_density2d).## Warning: Removed 69 rows containing non-finite values (stat_density2d).
# getting pharmacies that prescribe naloxone
library(RSocrata)
pharmacies <- read.socrata("https://data.ct.gov/resource/qjtc-pbhi.csv")
pharmacies <- pharmacies[c("Pharmacy", "Location")]
pharmacies$lat <- sub(".*\\(", "", pharmacies$Location)
pharmacies$lat <- sub(",.*", "", pharmacies$lat)
pharmacies$lon <- sub(".*,", "", pharmacies$Location)
pharmacies$lon <- sub("\\)", "", pharmacies$lon)
pharmacies$lon <- as.numeric(pharmacies$lon)## Warning: NAs introduced by coercionpharmacies$lat <- as.numeric(pharmacies$lat)## Warning: NAs introduced by coercionpharmacies <- na.omit(pharmacies)
pharmacies$category <- "pharmacy"
pharmacies <- pharmacies[c("Pharmacy", "category", "lon", "lat")]
colnames(pharmacies) <-c("Name", "category", "lon", "lat")
# hospitals
hospitals <- read.socrata("https://data.ct.gov/resource/pg64-zncr.csv")
hospitals$address <- paste(hospitals$Address, hospitals$City, hospitals$State, sep=", ")
# This is going to geocode the addresses
geo <- geocode(location = hospitals$address, output="latlon")## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=326%20WASHINGTON%20STREET,%20NORWICH,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=34%20MAPLE%20ST,%20NORWALK,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=80%20SEYMOUR%20STREET,%20HARTFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=267%20GRANT%20STREET,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=2800%20MAIN%20ST,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=112%20MANSFIELD%20AVE,%20WILLIMANTIC,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=31%20UNION%20STREET,%20Vernon,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=24%20HOSPITAL%20AVE,%20DANBURY,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=20%20YORK%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=300%20SEASIDE%20AVE,%20MILFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=201%20CHESTNUT%20HILL%20RD,%20STAFFORD%20SPRINGS,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=540%20LITCHFIELD%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=114%20WOODLAND%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=71%20HAYNES%20ST,%20MANCHESTER,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=BREWSTER%20RD,%20BRISTOL,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=263%20Farmington%20Avenue,%20FARMINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=365%20MONTAUK%20AVENUE,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=50%20GRISWORLD%20ST,%20NEW%20BRITAIN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=320%20POMFRET%20ST,%20PUTNAM,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=64%20ROBBINS%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=435%20LEWIS%20AVENUE,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=50%20Hospital%20Hill%20Road,%20SHARON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=5%20PERRYRIDGE%20RD,%20GREENWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=56%20FRANKLIN%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=28%20CRESCENT%20ST,%20MIDDLETOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=30%20Shelburne%20Road,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=130%20DIVISION%20ST,%20DERBY,%20CT&sensor=falsehospitals <- cbind(hospitals, geo)
hospitals <- hospitals[c("Name", "lon", "lat")]
hospitals$category <- "hospital"
# clinics
clinics <- read.socrata("https://data.ct.gov/resource/6wh6-dmxt.csv")
clinics$address <- paste(clinics$Address, clinics$City, clinics$State, sep=", ")
# This is going to geocode the addresses
geo2 <- geocode(location = clinics$address, output="latlon")## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=99%20SPRUCE%20ST,%20MIDDLETOWN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=78%20Hunts%20Brook%20Road,%20Quaker%20Hill,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=4%20MIDLAND%20RD,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=386%20NEW%20LONDON%20TPKE,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=74%20GROVE%20ST,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=42%20SAINT%20CASIMIR%20DR,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20LINCOLN%20BLVD,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=360%20COLUMBUS%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=471%20Barnum%20Avenue,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=495%20CONGRESS%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=163%20Broadway%20Street,%20Colchester,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=72%20HOSPITAL%20AVE,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=55%20STRAWBERRY%20HILL%20AVE,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=110%20MILL%20ST,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=64%20BLACK%20ROCK%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=150%20FOURNIER%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=121%20WAKELEE%20AVE,%20ANSONIA,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=208%20MAIN%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=70%20OVERLOOK%20DR,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=60%20LAFAYETTE%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=752%20E%20MAIN%20ST,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=75%20MAIN%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=594%20BURRITT%20ST,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=51%20DANIELS%20AVE,%20WATERFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=263%20FARMINGTON%20AVE,%20FARMINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=20%20N%20MAIN%20ST,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=19%20HORTON%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=55%20LOCK%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=305%20BROADWAY,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=62%20GRANT%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1071%20E%20MAIN%20ST,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=634%20Main%20Street,%20Middletown,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1734%20CENTRAL%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=32%20UNION%20ST,%20WINSTED,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=651%20STATE%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=27%20CHESTNUT%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=133%20PARKER%20AVE,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=968%20FAIRFIELD%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=19-45%20LINCOLN%20CITY%20ROAD,%20LAKEVILLE,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=392%20PROSPECT%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=83%20LOCKWOOD%20AVE,%20STAMFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1302%20S%20MAIN%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=597%20PACIFIC%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=6448%20MAIN%20ST,%20TRUMBULL,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=2800%20Tamarack%20Avenue,%20South%20Windsor,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=5%20N%20MAIN%20ST,%20ENFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1075%20CHASE%20PKWY,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=196%20BLOOMFIELD%20AVE,%20WEST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=337%20E%20RIVER%20DR,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=95%20Thomaston%20Avenue,%20Waterbury,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=78%20Franklin%20Square,%20New%20Britain,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=680%20PARK%20AVENUE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=270%20MOHEGAN%20AVE,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=80%20PHOENIX%20AVE,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=625%20Main%20Street,%20Middletown,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=114%20BENEDICT%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=165%20Golden%20Street%20Extension,%20Norwich,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=130%20Orchard%20Street,%20New%20Haven,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=46%20N%20PLAINS%20INDUSTRIAL%20RD,%20WALLINGFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=114%20Truman%20Street,%20New%20Haven,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=90%20Fairfield%20Avenue,%20Stamford,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=805%20ATLANTIC%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=56%20Farm%20Drive,%20East%20Hartford,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=160%20Iranistan%20Avenue,%20Bridgeport,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=13%20Rose%20Street,%20Danbury,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=44%20E%20RAMSDELL%20ST%20#%2054,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=809%20ASYLUM%20AVENUE,%20ANEX%20BLD.,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=202%20BLACHLEY%20RD,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=164%20GRAND%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=124%20COLUMBIA%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=500%20POQUONNOCK%20ROAD,%20GROTON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=426%20W%20MAIN%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=70%20MAIN%20ST,%20JEWETT%20CITY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=381%20HIGH%20RIDGE%20RD,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=130%20BASSETT%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=123%20QUARRY%20ST,%20WILLIMANTIC,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=150%20NORTH%20MAIN%20STREET,%20SUITES%20240%20&%20230,%20MANCHESTER,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=370%20Hunting%20Hill%20Road,%20Middletown,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=76%20WEST%20ST,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=120%20CONNECTICUT%20AVE,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=135%20BROAD%20ST,%20HARTFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20Long%20Wharf%20Drive,%20Suite%2010,%20New%20Haven,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=11%20W%20NORTH%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=232%20Cedar%20Street,%20New%20Haven,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=100%20JAMES%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=250%20BRANDEGEE%20AVE,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=82-88%20%20GEORGE%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=282%20WASHINGTON%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=64%20N%20PEARL%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=2800%20Tamarack%20Avenue,%20South%20Windsor,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=469%20MIGEON%20AVE,%20TORRINGTON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=100%20CLEARVIEW%20AVE,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=141%20FRANKLIN%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=50%20MERCER%20ST,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=21%20Grand%20Street,%20Hartford,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=15%20TEACHERS%20DR,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=3%20PROSPECT%20ST,%20VERNON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=800%20Still%20Water%20Road,%20Stamford,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=949%20BRIDGEPORT%20AVE,%20MILFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=48%20CRYSTAL%20AVE%20BLDG%20A,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=13%20WOLCOTT%20ST,%20WATERBURY,%20CT&sensor=false
## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=13%20WOLCOTT%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=146%20HUNTINGDON%20AVE,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=22%20TOMPKINS%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=80%20NORWICH%20NEW%20LONDON%20TPKE,%20UNCASVILLE,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=500%20PALISADE%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=200%20WILMOT%20RD,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=365%20WILLARD%20AVE%20STE%202E,%20NEWINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=220%20COE%20AVE,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=743%20COLONEL%20LEDYARD%20HWY,%20LEDYARD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=8%20WOODLAND%20PL,%20STAMFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1755%20PARK%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=104%20VINE%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20Bulkeley%20Place,%20New%20London,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=190%20GOVERNOR%20WINTHROP%20BLVD,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=115%20HIGHLAND%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=293%20CLINTON%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=241-249%20Arch%20Street,%20New%20Britain,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=137%20East%20Avenue,%20Norwalk,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=777%20BURNSIDE%20AVE,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=90-100%20CEDAR%20GROVE,%20NEW%20LONDON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=375%20Quinnipiac%20Avenue,%20New%20Haven,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=277%20ATKINS%20STREET%20EXT,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=49%20DAY%20ST,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=66%20SPRING%20ST,%20MIDDLETOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=727%20HONEYSPOT%20RD,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=101%20CATHERINE%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=361%20Bird%20Street,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=22%20MASONIC%20AVE,%20WALLINGFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=55%20FOREST%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=790%20CENTRAL%20AVE,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=47%20Crescent%20Street,%20WILLIMANTIC,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=490%20Jefferson%20Avenue,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=125%20ROXBURY%20ROAD,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=224%20HARTFORD%20TPKE,%20VERNON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=200%20LA%20ROSA%20LN,%20MIDDLETOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=339%20EASTERN%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=134%20STATE%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=101%20GROTON%20LONG%20POINT%20RD,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=982%20E%20MAIN%20ST%20#%20988,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=BACKUS%20HEALTH%20CENTER,%201666%20ROUTE%2012,%20GALES%20FERRY,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=285%20MAIN%20ST,%20WEST%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=21%20GRAND%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=195%20Hillandale%20Avenue,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=560%20PARK%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=111%20HILLSIDE%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=55%20WAVERLY%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=24%20ROPE%20FERRY%20RD,%20WATERFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=381%20HIGH%20RIDGE%20ROAD,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1551%20BLUE%20HILLS%20AVE,%20BLOOMFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=586%20ELLA%20T%20GRASSO%20BLVD,%20NEW%20HAVEN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=112%20Bow%20Lane,%20Middletown,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=61%20FORT%20HILL%20RD,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=8%20DeLay%20Street,%20Danbury,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=50%20NICHOLS%20STREET,%20FAIRFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=401%20NEW%20BRITAIN%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=56%20Hawkins%20Street,%20New%20Britain,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=137%20EAST%20AVENUE,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1046%20FAIRFIELD%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=123%20Ridgewood%20Avenue,%20Stamford,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=57%20NORTH%20ST%20STE%20103-104-,%20DANBURY,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=374%20GRAND%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=200%20WILMOT%20RD,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=300%20WETHERSFIELD%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=7%20VAUXHALL%20STREET,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=GATEWAY%20CENTER%2054%20MEADOW%20STREET,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=250%20BRANDEGEE%20AVE,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=85%20LAFAYETTE%20STREET,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=401%20FLATBUSH%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=743%20SOUTH%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=37%20BEECH%20DRIVE,%20NEW%20LONDON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=2040%20DIXWELL%20AVE,%20HAMDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1000%20ASYLUM%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=40%20Goodwin%20Street,%20New%20Britain,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=15%20MERCER%20AVE,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=435%20E%20MAIN%20ST,%20ANSONIA,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=25%20RIDGEFIELD%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1841%20BROAD%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20LABELLA%20CIR,%20MIDDLETOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=398%20LIBERTY%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=869%20FORBES%20ST,%20EAST%20HARTFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=10%20CAMPFIELD%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=59%20North%20Main%20Street,%20Bristol,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=474%20SCHOOL%20ST,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=LINCOLN%20AVENUE-36%20WALLER%20STREET,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=415%20GRANBY%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=432%20MONTAUK%20AVENUE,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=130%20EZRA%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=34%20HUYSHOPE%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=333%20LONG%20HILL%20ROAD,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=77%20WOODLAWN%20TER,%20WATERBURY,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=51%20TOMS%20ROAD,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=150%20LINCOLN%20ST,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=176%20BABCOCK%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=300%20SUMMIT%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=114%20East%20Main%20Street,%20Clinton,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=326%20WASHINGTON%20ST,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=25%20MAHAN%20DR,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=54%20Reynolds%20Street,%20Danielson,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=12-14%20WESTON%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1351%20WASHINGTON%20BLVD,%20STAMFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=215%20South%20Street,%20Hartford,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=425%20THORME%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=23%20CALVIN%20MURPHY%20DR,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=165%20MILLER%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=121%20Water%20Street,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=470%20Maple%20Avenue,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=495%20JANE%20STREET,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=500%20ALBANY%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=437%20SHELDON%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=One%20Salem%20Street,%20COS%20COB,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=230%20GEORGE%20STREET,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=101%20FIELD%20POINT%20RD,%20GREENWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=350%20MAIN%20AVE,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=167%20RIVERSIDE%20DRIVE,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=121%20GRAVEL%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=690%20ARTIC%20STREET,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20HARRY%20DAY%20DR,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=437%20PEQUOT%20AVE,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=560%20ELLA%20T%20GRASSO%20BLVD%20STE%203,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=400%20BAYONET%20ST,%20NEW%20LONDON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=30%20Elizabeth%20Street,%20Derby,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=49%20WINTHROP%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=355%20MAIN%20ST,%20WEST%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20ABRAHMS%20BLVD,%20WEST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=135%20N%20PLAINS%20INDUSTRIAL%20RD,%20WALLINGFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=625%20BALDWIN%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=37C%20Kennedy%20Drive,%20Putnam,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=60%20BEAVER%20BROOK%20RD,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=138%20STILLWATER%20AVE,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=800%20CHARLES%20STREET,%20TORRINGTON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=340%20LITCHFIELD%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=80%20%20HILLTOP%20ROAD,%20SHARON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=215%20HOGAN%20DR,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=500%20MIGEON%20AVENUE,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=9%20JUDD%20AVENUE,%20KENT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=47%20MAIN%20ST%20ROUTE%20126,%20FALLS%20VILLAGE,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=425%20GRANT%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20LONG%20WHARF%20DR%20STE%20321,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=115%20SPENCER%20STREET,%20WINSTED,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=57%20NORTH%20ST,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=40%20MANSFIELD%20AVE,%20WILLIMANTIC,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=42%20CHARTER%20OAK%20AVENUE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=65%20VAN%20BLOCK%20AVENUE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=75%20CLARK%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=195%20PUTNAM%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=719%20BIRDSEYE%20ST,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=960%20MAIN%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1750%20MAIN%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=35%20REDDEN%20AVE,%20NEW%20LONDON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=495%20WATERVIEW%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=791%20WEST%20MIDDLE%20TURNPIKE,%20MANCHESTER,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=3180%20MAIN%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=130%20SHENNECOSSET%20ROAD,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=151%20FARMINGTON%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=105%20SPRING%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=5%20CREAM%20HILL%20ROAD,%20CORNWALL,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=68%20CHURCH%20STREET,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=90%20PEASE%20ST,%20CANAAN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=200%20MIDDLE%20SCHOOL%20DRIVE,%20TORRINGTON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=229%20NORTH%20STREET,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=12%20CASE%20ST%20STE%20305,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=35%20DAVIS%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=34%20PARK%20ST%20#%20261,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=275%20GEORGE%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=46%20ALBION%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1124%20IRANISTAN%20AVENUE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=94%20Connecticut%20Boulevard,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=226%20DIXWELL%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=141%20FRANKLIN%20ST,%20STAMFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=47%20TOWN%20STREET,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=131%20COVENTRY%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=411%20OSGOOD%20AVE,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=3%20FARM%20RD,%20NEW%20CANAAN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=142%20HAZARD%20AVE,%20ENFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=118%20MAIN%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=300%20HIGHLAND%20AVE,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=481%20GOLD%20STAR%20HWY%20STE%20100,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=95%20SCOVILL%20STREET,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=510%20CLINTON%20AVE,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=911%20State%20Street,%20New%20Haven,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=400%20COLUMBUS%20AVE%20#%20428,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=98%20S%20MAIN%20ST,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=14%20SYCAMORE%20WAY,%20BRANFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=479%20HELEN%20ST,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=43%20Clapboard%20Ridge%20Road,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=200%20BLOOMFIELD%20AVE,%20WEST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=330%20WASHINGTON%20ST%20STE%20510,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=700%20PALISADES%20PARKWAY,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=245%20LOCUST%20STREET,%20HARTFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=157%20LITCHFIELD%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=8%20MAHAN%20DR,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=263%20MAIN%20ST,%20OLD%20SAYBROOK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20SHAWS%20COVE,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=5151%20PARK%20AVENUE,%20FAIRFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=100%20HAYNES%20ST,%20MANCHESTER,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=395%20LYME%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=426%20EAST%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=120-122%20PLAINFIELD%20ROAD,%20MOOSUP,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1181%20FAIRFIELD%20AVE,%20BRIDGEPORT,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=153%20S%20MAIN%20ST,%20NEWTOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=120%20CONNECTICUT%20AVE,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=191%20MAIN%20ST,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=202%20POMFRET%20ST,%20PUTNAM,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=395%20N%20MAIN%20ST,%20BRISTOL,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=260%20HOLCOMB%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=470%20MAPLE%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=150%20TOWER%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=20%20CHURCH%20ST%20RM%20N,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=35%20WICKER%20ST,%20PUTNAM,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=37%20BEECH%20DR,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=40%20FIELD%20ST,%20PAWCATUCK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=445%20UNION%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=75%20CLARK%20ST,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=94%20CONNECTICUT%20BLVD,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=43%20TOMPKINS%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=75%20OLIVER%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=51%20DANIELS%20AVE,%20WATERFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=701%20SUITE%20A%20#210%20COTTAGE%20GROVE%20ROAD,%20BLOOMFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=289%20WILLOW%20ST,%20WATERBURY,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=60%20DANIELS%20ST,%20MIDDLETOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=189%20FORT%20HILL%20RD,%20GROTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=730%20STATE%20PIER%20RD,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=7%20MAHAN%20DR,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20ROYCE%20CIR%20STE%20108,%20STORRS%20MANSFIELD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=42%20TOWN%20ST%20STE%20300,%20NORWICH,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=10%20N%20MAIN%20ST,%20BRISTOL,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=21%20MEMORIAL%20DR,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=43%20CLAPBOARD%20RIDGE%20RD,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=95%20NEW%20LITCHFIELD%20ST,%20TORRINGTON,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=11%20W%20NORTH%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=254%20CROWN%20ST,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=76%20S%20MAIN%20ST,%20EAST%20WINDSOR,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=347%20STILLWATER%20AVE,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=20%20MAPLE%20ST,%20VERNON%20ROCKVILLE,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=250%20HOLLISTER%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=70%20LOVELAND%20HILL%20RD,%20VERNON%20ROCKVILLE,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=196%20PARKWAY%20S%20STE%20201B,%20WATERFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=298%20OREGON%20RD,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=71%20JONES%20ROAD,%20MIDDLETOWN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=618%20WEST%20AVE,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=350%20BARBOUR%20STREET,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=181%20MITCHELL%20DR,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=165%20MILLER%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=305%20Greenfield%20Street,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1315%20MAIN%20STREET,%20WILLIMANTIC,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=99%20COSEY%20BEACH%20RD,%20EAST%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=88%20E%20ALBERT%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=60%20COMMERCE%20ST,%20EAST%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=352%20STATE%20ST,%20NORTH%20HAVEN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=136%20BERLIN%20RD,%20CROMWELL,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=675%20MAIN%20ST,%20MIDDLETOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=281%20MAIN%20ST,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=606%20HOWARD%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1%20JEFFERSON%20SQ,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=300%20PIERPONT%20RD,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=840%20OLD%20TOWN%20RD,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=9%20RIVERSIDE%20DRIVE,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=140%20DEWITT%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1895%20BARNUM%20AVE,%20STRATFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=503%20WINDSOR%20AVE,%20WINDSOR,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=83%20LOCKWOOD%20AVE,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=332%20S%20MAIN%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=75%20SELLECK%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=88%20HAMILTON%20AVE,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=90%20FAIRFIELD%20AVE,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=735%20SLATER%20ROAD,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=110%20CONNECTICUT%20BLVD,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=160%20FISHTOWN%20RD,%20MYSTIC,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=21%20HAYESTOWN%20AVE,%20DANBURY,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=160%20IRANISTAN%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=4%20MERRITT%20ST,%20NORWALK,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=88%20PROSPECT%20ST,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=175%20WEST%20ST,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=51%20N%20ELM%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=600%20ORANGE%20AVE,%20MILFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=403%20MAIN%20ST,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=95%20SCOVILL%20ST,%20WATERBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=32%20HUNTINGTON%20ST,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=396%20NICHOLS%20AVE,%20STRATFORD,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=95%20CHURCH%20ST,%20HAMDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=11%20QUEEN%20ST,%20NEWTOWN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=101%20GREAT%20HILL%20RD,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=151%20FARMINGTON%20AVE,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=72%20HOSPITAL%20AVE,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=164%20CENTENNIAL%20AVE,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=265%20ELLINGTON%20RD.%20UNIT%20C%20350,@%20SCHOOL%20ST.PLAZA,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=41%20NEW%20STREET,%20DANBURY,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=949%20BRIDGEPORT%20AVE,%20MILFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=591%20Poquonnock%20Road,%20Groton,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=587%20MIDDLE%20TPKE%20E%20STE%20A,%20MANCHESTER,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=351%20FRONTAGE%20ROAD,%20NEW%20LONDON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=19%20WOODLAND%20ST%20STE%2021,%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=33%20CHURCH%20ST,%20EAST%20HARTFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=800%20OLD%20COLCHESTER%20RD,%20OAKDALE,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=157%20LITCHFIELD%20ST,%20TORRINGTON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=170%20DERBY%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=140%20DEWITT%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=150%20FOURNIER%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=259%20EDGEWOOD%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=114%20TRUMAN%20ST,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=50%20GRAND%20AVE,%20NEW%20HAVEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=205%20E%20THOMPSON%20RD,%20THOMPSON,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=45%20N%20PARADE%20ST,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=45%20BIRDSEYE%20ST,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=490%20CHAPEL%20ST,%20STRATFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=120%20BRIDGE%20ST,%20STAMFORD,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=322%20SLATER%20RD,%20NEW%20BRITAIN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1225%20BROAD%20ST,%20MERIDEN,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=124%20COLUMBIA%20ST,%20MERIDEN,%20CT&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=300%20LAUREL%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=680%20PARK%20AVE,%20BRIDGEPORT,%20CT&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=137%20HENRY%20ST,%20STAMFORD,%20CT&sensor=falseclinics <- cbind(clinics, geo2)
clinics <- clinics[c("Name", "lon", "lat")]
clinics$category <- "outpatient"
# Treatment centers
treat <- read.csv("data/treatmentcenters.csv", stringsAsFactors=FALSE)
treat$Address <- gsub("\\\xca", " ", treat$Address)
# This is going to geocode the addresses
geo3 <- geocode(location = treat$Address, output="latlon")## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=20%20North%20Main%20Street,%20Norwalk,%20CT%2006854&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=2%20Research%20Drive,%20Stratford,%20CT%2006615&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=115-125%20Main%20Street,%20Stamford,%20CT%2006901&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1438%20Park%20Avenue,%20Bridgeport,%20CT%2006604&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=399%20Mill%20Hill%20Avenue,%20Bridgeport,%20CT%2006610&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=3851%20Main%20Street,%20Bridgeport,%20CT%2006606&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=495%20Congress%20Avenue,%20New%20Haven,%20CT%2006519&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=426%20East%20Street,%20New%20Haven,%20CT%2006511&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=540%20Ella%20T%20Grasso%20Boulevard,%20New%20Haven,%20CT%2006519&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=232%20Cedar%20Street,%20New%20Haven,%20CT%2006519&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=311%20East%20Street,%20New%20Haven,%20CT%2006511&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=931%20Bank%20Street,%20New%20London,%20CT%2006320&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=54-56%20Boston%20Post%20Road,%20Willimantic,%20CT%2006226&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=772%20West%20Thames%20Street,%20Norwich,%20CT%2006360&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=995%20Day%20Hill%20Road,%20Windsor,%20CT%2006095&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=345%20Main%20Street,%20Hartford,%20CT%2006106&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=70%20Whiting%20Street,%20New%20Britain,%20CT%2006051&sensor=false## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=12-14%20Weston%20Street,%20Hartford,%20CT%2006106&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=55%20Fishfry%20Street,%20Hartford,%20CT%2006120&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=1098%20Farmington%20Avenue,%20Bristol,%20CT%2006010&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=345%20Broad%20Street,%20Manchester,%20CT%2006040&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=60%20Beaver%20Brook%20Road,%20Danbury,%20CT%2006810&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=4%20Midland%20Road,%20Waterbury,%20CT%2006705&sensor=false## .## Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=140%20Commercial%20Blvd.,%20Torrington,%20CT%2006040&sensor=falsetreat<- cbind(treat, geo3)
treat <- treat[c("Name", "lon", "lat")]
treat$category <- "treatment center"
treat <- na.omit(treat)
# mapping out all these locations
the_list <- rbind(treat, clinics, hospitals, pharmacies)
map_lat <- c(42.107156, 40.919869)
map_lon <- c(-73.824298, -71.478997)
map <- get_map(c(lon = mean(map_lon), lat = mean(map_lat)), zoom = 8, maptype = 'toner')## maptype = "toner" is only available with source = "stamen".## resetting to source = "stamen"...## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=41.513513,-72.651647&zoom=8&size=640x640&scale=2&maptype=terrain&sensor=false## Map from URL : http://tile.stamen.com/toner/8/75/94.png## Map from URL : http://tile.stamen.com/toner/8/76/94.png## Map from URL : http://tile.stamen.com/toner/8/77/94.png## Map from URL : http://tile.stamen.com/toner/8/75/95.png## Map from URL : http://tile.stamen.com/toner/8/76/95.png## Map from URL : http://tile.stamen.com/toner/8/77/95.png## Map from URL : http://tile.stamen.com/toner/8/75/96.png## Map from URL : http://tile.stamen.com/toner/8/76/96.png## Map from URL : http://tile.stamen.com/toner/8/77/96.pngggmap(map) +
stat_density2d(aes(x = X, y = Y, fill = ..level.., alpha = ..level..),
size = 2, bins = 4, data = ct_gg, geom = "polygon") +
geom_point(data = the_list, aes(x = lon, y = lat, color = category), size=1)## Warning: Removed 6 rows containing missing values (geom_point).
# densitymap & dots
#ggplot(choropleth, aes(long, lat, group = group)) +
# geom_polygon(aes(fill = rate_d), colour = alpha("white", 1/2), size = 0.2) +
# geom_polygon(data = state_df, colour = "white", fill = NA) +
# scale_fill_brewer(palette = "PuRd")
# choropleth & dots
dtm <- ggmap(map) +
geom_polygon(data = drugs_total_map, aes(x=long, y=lat, group=group, fill=Total), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
geom_point(data = the_list, aes(x = lon, y = lat, color = category), size=1) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town since 2012", fill="")
dtm## Warning: Removed 6 rows containing missing values (geom_point).
dtm <- ggmap(map) +
geom_polygon(data = drugs_total_map, aes(x=long, y=lat, group=group, fill=percapita), color = "black", size=0.2) +
coord_map() +
scale_fill_distiller(type="seq", trans="reverse", palette = "Reds", breaks=pretty_breaks(n=10)) +
geom_point(data = the_list, aes(x = lon, y = lat, color = category), size=1) +
theme_nothing(legend=TRUE) +
labs(title="Total overdose deaths by town since 2012", fill="")
dtm## Warning: Removed 6 rows containing missing values (geom_point).